<?php
if (!defined('sugarEntry')) {
    session_start();
    session_destroy();
    header("Location: ../iphone.php");
}
/*********************************************************************************
* SugarCRM is a customer relationship management program developed by
* SugarCRM, Inc. Copyright (C) 2004 - 2007 SugarCRM Inc.
*
* This program is free software; you can redistribute it and/or modify it under
* the terms of the GNU General Public License version 3 as published by the
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
* details.
*
* You should have received a copy of the GNU General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road, 
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU General Public License version 3.
*
* In accordance with Section 7(b) of the GNU General Public License version 3, 
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
/*********************************************************************************
* Function:    sugar-iphone-client for SugarCRM
* Description: Include file: Metadata of the ThinClient
* Author:      Editha Kuske - 2008,Richard John Jensen 2009
* Revision:      $Id: meta_array.php 5 2009-12-24 05:49:32Z richardjohnjensen $
********************************************************************************/

$ar_calls_descr = array(str_head => 'Calls',module_name => 'Calls',bean_table => 'calls');
$ar_meetings_descr = array(str_head => 'Meetings',module_name => 'Meetings',bean_table => 'meetings');
$ar_project_tasks_descr = array(str_head => 'ProjectTasks',module_name => 'ProjectTask',bean_table => 'project_task');
$ar_beans =array(
/*
  'Calendar' => array(
     'thin_bean' => "Calendar",
     'module_name' => "Calendar",
     'bean_table' => "calls"
      ),
*/
  'Accounts' => array(
     'thin_bean' => "Account",
     'module_name' => "Accounts",
     'bean_table' => "accounts",
     'main_menu' => "visible"
      ),
  'Contacts' => array(
     'thin_bean' => "Contact",
     'module_name' => "Contacts",
     'bean_table' => "contacts",
     'main_menu' => "visible"
      ),
  'Opportunities' => array(
     'thin_bean' => "Opportunity",
     'module_name' => "Opportunities",
     'bean_table' => "opportunities",
     'main_menu' => "visible"
      ),
  'Leads' => array(
     'thin_bean' => "Lead",
     'module_name' => "Leads",
     'bean_table' => "leads",
     'main_menu' => "visible"
      ),
  'Calls' => array(
     'thin_bean' => "Call",
     'module_name' => "Calls",
     'bean_table' => "calls",
     'main_menu' => "visible"
      ),
  'Meetings' => array(
     'thin_bean' => "Meeting",
     'module_name' => "Meetings",
     'bean_table' => "meetings",
     'main_menu' => "visible"
      ),
//EK projects start
  'Project' => array(
     'thin_bean' => "Project",
     'module_name' => "Project",
     'bean_table' => "project",
//     'main_menu' => "not_visible"
     'main_menu' => "visible"
      ),
  'ProjectTask' => array(
     'thin_bean' => "ProjectTask",
     'module_name' => "ProjectTask",
     'bean_table' => "project_task",
//     'main_menu' => "not_visible"
     'main_menu' => "visible"
      ),

//EK projects end
 );

$ar_meta_data = array(
// -------------------------------------------------------------------------------
//EK projects start
  'Project' => array(
    'assigned_user_name' => array(
       'id' => '3',
       'bean' => 'Project',
       'bean_table' => 'project',
       'label' => '',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '0',
       'orderby' => '0'),
    'assigned_user_id' => array(
       'id' => '3',
       'bean' => 'Project',
       'bean_table' => 'project',
       'label' => 'Assigned to',
       'fieldname' => 'assigned_user_id',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'name' => array(
       'id' => '76',
       'bean' => 'Project',
       'bean_table' => 'project',
       'label' => 'Subject',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '1'),
    'status' => array(
       'id' => '80',
       'bean' => 'Project',
       'bean_table' => 'project',
       'label' => 'Status',
       'fieldname' => 'status',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '40'),
    'estimated_start_date' => array(
       'id' => '96',
       'bean' => 'Project',
       'bean_table' => 'project',
       'label' => 'Start Date',
       'fieldname' => 'estimated_start_date',
       'fieldtype' => 'date',
       'statement' => '',
       'required' => '0',
       'visible' => '1',
       'orderby' => '200'),
    'estimated_end_date' => array(
       'id' => '96',
       'bean' => 'Project',
       'bean_table' => 'project',
       'label' => 'End Date',
       'fieldname' => 'estimated_end_date',
       'fieldtype' => 'date',
       'statement' => '',
       'required' => '0',
       'visible' => '1',
       'orderby' => '200'),
    'description' => array(
       'id' => '47',
       'bean' => 'Project',
       'bean_table' => 'project',
       'label' => 'Description',
       'fieldname' => 'description',
       'fieldtype' => 'textarea',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '60'),
       ),

  'ProjectTask' => array(
    'assigned_user_name' => array(
       'id' => '3',
       'bean' => 'ProjectTask',
       'bean_table' => 'project_task',
       'label' => '',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '0',
       'orderby' => '0'),
    'assigned_user_id' => array(
       'id' => '3',
       'bean' => 'ProjectTask',
       'bean_table' => 'project_task',
       'label' => 'Assigned to',
       'fieldname' => 'assigned_user_id',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'name' => array(
       'id' => '76',
       'bean' => 'ProjectTask',
       'bean_table' => 'project_task',
       'label' => 'Subject',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '1'),
    'status' => array(
       'id' => '80',
       'bean' => 'ProjectTask',
       'bean_table' => 'project_task',
       'label' => 'Status',
       'fieldname' => 'status',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '40'),
    'date_start' => array(
       'id' => '96',
       'bean' => 'ProjectTask',
       'bean_table' => 'project_task',
       'label' => 'Start Date',
       'fieldname' => 'date_start',
       'fieldtype' => 'date',
       'statement' => '',
       'required' => '0',
       'visible' => '1',
       'orderby' => '200'),
    'date_finish' => array(
       'id' => '96',
       'bean' => 'ProjectTask',
       'bean_table' => 'project_task',
       'label' => 'Finish Date',
       'fieldname' => 'date_finish',
       'fieldtype' => 'date',
       'statement' => '',
       'required' => '0',
       'visible' => '1',
       'orderby' => '200'),
    'project_id' => array(
       'id' => '96',
       'bean' => 'ProjectTask',
       'bean_table' => 'project_task',
       'label' => 'Project Id',
       'fieldname' => 'project_id',
       'fieldtype' => 'varchar',
       'statement' => '',
       'required' => '0',
       'visible' => '0',
       'orderby' => '200'),

    'project_name' => array(
       'id' => '96',
       'bean' => 'ProjectTask',
       'bean_table' => 'project_task',
       'label' => 'Project',
       'fieldname' => '',
       'fieldtype' => 'show_only',
       'statement' => '',
       'required' => '0',
       'visible' => '1',
       'orderby' => '200'),
    'description' => array(
       'id' => '47',
       'bean' => 'ProjectTask',
       'bean_table' => 'project_task',
       'label' => 'Description',
       'fieldname' => 'description',
       'fieldtype' => 'textarea',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '60'),
       ),
/* weitere Felder von ProjectTask
8	predecessors	0	text		Predecessors:
13	duration	0	int		Duration:
14	duration_unit	0	text	Days
Hours	Duration Unit:
15	actual_duration	0	int		Actual Duration:
16	percent_complete	0	int		Percent Complete (%):
17	parent_task_id	0	int		Parent Task Id:
19	modified_user_id	0	assigned_user_name		Modified User Id:
20	modified_by_name	0	assigned_user_name		Modified User Id:
21	priority	0	enum	High
Medium
Low	Priority:
22	created_by	0	assigned_user_name		Created By:
23	created_by_name	0	assigned_user_name		Created By:
24	milestone_flag	0	bool		Milestone:
25	order_number	0	int		Order:
26	task_number	0	int		Task Number:
27	estimated_effort	0	int		Estimated Effort (hrs):
28	actual_effort	0	int		Actual Effort (hrs):
29	deleted	0	bool		Deleted:
30	utilization	0	int		Utilization (%):
*/
//EK projects end
// -------------------------------------------------------------------------------
  'Call' => array(
    'assigned_user_name' => array(
       'id' => '3',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => '',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '0',
       'orderby' => '0'),
    'assigned_user_id' => array(
       'id' => '3',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Assigned to',
       'fieldname' => 'assigned_user_id',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'name' => array(
       'id' => '76',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Subject',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '1'),
    'date_start' => array(
       'id' => '77',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Start Date',
       'fieldname' => 'date_start',
       'fieldtype' => 'date_part',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '2'),
    'time_start' => array(
       'id' => '91',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Start Time',
       'fieldname' => 'time_start',
       'fieldtype' => 'time_part',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '3'),
    'duration' => array(
       'id' => '78',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Duration (h:mm)',
       'fieldname' => 'duration',
       'fieldtype' => 'duration',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '19'),
    'duration_hours' => array(
       'id' => '78',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Duration Hours',
       'fieldname' => 'duration_hours',
       'fieldtype' => 'hours',
       'statement' => '',

       'required' => '0',
       'visible' => '0',
       'orderby' => '19'),
    'duration_minutes' => array(
       'id' => '89',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Duration Minutes',
       'fieldname' => 'duration_minutes',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '0',
       'visible' => '0',
       'orderby' => '20',
       'options' => array(
          '15' => '15',
          '30' => '30',
          '45' => '45',
          '00' => '00',
        )),
    'direction' => array(
       'id' => '79',
       'bean' => 'Calendar',
       'bean_table' => 'calls',
       'default_val' => '',
       'label' => 'Direction',
       'fieldname' => 'direction',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '30'),
    'status' => array(
       'id' => '80',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Status',
       'fieldname' => 'status',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '40'),
    'parent_type' => array(
       'id' => '93',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Related to',
       'fieldname' => 'parent_type',
       'fieldtype' => 'hidden',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '100'),
    'parent_id' => array(
       'id' => '94',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Related Name',
       'fieldname' => 'parent_id',
       'fieldtype' => 'hidden',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '110'),
    'date_end' => array(
       'id' => '96',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'End Date',
       'fieldname' => 'date_end',
       'fieldtype' => 'set_equal',
       'statement' => '?+date_start?',

       'required' => '0',
       'visible' => '0',
       'orderby' => '200'),
    'description' => array(
       'id' => '47',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Description',
       'fieldname' => 'description',
       'fieldtype' => 'textarea',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '60'),
    'calls_contacts' => array(
       'id' => '3',
       'bean' => 'Call',
       'related_bean' => 'Contacts',
       'bean_table' => 'calls',
       'label' => 'Invitees',
       'fieldname' => 'invitees',
       'fieldtype' => 'search_enum',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),
       ),
// -------------------------------------------------------------------------------
  'Meeting' => array(
    'assigned_user_name' => array(
       'id' => '3',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => '',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',
       'required' => '0',
       'visible' => '0',
       'orderby' => '0'),
    'assigned_user_id' => array(
       'id' => '3',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => 'Assigned to',
       'fieldname' => 'assigned_user_id',
       'fieldtype' => 'enum',
       'statement' => '',
       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'name' => array(
       'id' => '84',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => 'Subject',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',
       'required' => '1',
       'visible' => '1',
       'orderby' => '1'),
    'date_start' => array(
       'id' => '77',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => 'Start Date',
       'fieldname' => 'date_start',
       'fieldtype' => 'date_part',
       'statement' => '',
       'required' => '1',
       'visible' => '1',
       'orderby' => '2'),
    'time_start' => array(
       'id' => '91',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => 'Start Time',
       'fieldname' => 'time_start',
       'fieldtype' => 'time_part',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '3'),
    'duration' => array(
       'id' => '78',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => 'Duration (h:mm)',
       'fieldname' => 'duration',
       'fieldtype' => 'duration',
       'statement' => '',
       'required' => '1',
       'visible' => '1',
       'orderby' => '19'),
    'duration_hours' => array(
       'id' => '78',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => 'Duration Hours',
       'fieldname' => 'duration_hours',
       'fieldtype' => 'hours',
       'statement' => '',
       'required' => '0',
       'visible' => '0',
       'orderby' => '19'),
    'duration_minutes' => array(
       'id' => '89',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => 'Duration Minutes',
       'fieldname' => 'duration_minutes',
       'fieldtype' => 'enum',
       'statement' => '',
       'required' => '0',
       'visible' => '0',
       'orderby' => '20',
       'options' => array(
          '15' => '15',
          '30' => '30',
          '45' => '45',
          '00' => '00',
        )),
    'parent_type' => array(
       'id' => '93',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => 'Related to',
       'fieldname' => 'parent_type',
       'fieldtype' => 'hidden',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '100'),
    'parent_id' => array(
       'id' => '94',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => 'Related Name',
       'fieldname' => 'parent_id',
       'fieldtype' => 'hidden',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '110'),
    'status' => array(
       'id' => '87',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => 'Status',
       'fieldname' => 'status',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '30'),
    'description' => array(
       'id' => '47',
       'bean' => 'Meeting',
       'bean_table' => 'meetings',
       'label' => 'Description',
       'fieldname' => 'description',
       'fieldtype' => 'textarea',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '60'),
    'meetings_contacts' => array(
       'id' => '3',
       'bean' => 'Meetings',
       'related_bean' => 'Contacts',
       'bean_table' => 'meetings',
       'label' => 'Invitees',
       'fieldname' => 'invitees',
       'fieldtype' => 'search_enum',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),
       ),
// -------------------------------------------------------------------------------
  'Account' => array(
    'assigned_user_name' => array(
       'id' => '3',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'label' => '',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '0',
       'orderby' => '0'),
    'assigned_user_id' => array(
       'id' => '3',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'label' => 'Assigned to',
       'fieldname' => 'assigned_user_id',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'name' => array(
       'id' => '27',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Account Name',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '1'),
    'account_type' => array(
       'id' => '28',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Type',
       'fieldname' => 'account_type',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '2'),
    'industry' => array(
       'id' => '29',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Industry',
       'fieldname' => 'industry',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '3'),
    'ownership' => array(
       'id' => '30',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Ownership',
       'fieldname' => 'ownership',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '4'),
    'ticker_symbol' => array(
       'id' => '31',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Ticker Symbol',
       'fieldname' => 'ticker_symbol',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '5'),
    'website' => array(
       'id' => '32',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Website',
       'fieldname' => 'website',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '6'),
    'phone_office' => array(
       'id' => '33',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Phone Office',
       'fieldname' => 'phone_office',
       'fieldtype' => 'phone',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '7'),
    'phone_fax' => array(
       'id' => '34',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Fax',
       'fieldname' => 'phone_fax',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '8'),
    'phone_alternate' => array(
       'id' => '35',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Alternate Phone',
       'fieldname' => 'phone_alternate',
       'fieldtype' => 'phone',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '9'),
    'employees' => array(
       'id' => '36',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Employees',
       'fieldname' => 'employees',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '10'),
    'spacer_billing_adr' => array(
       'id' => '82',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Billing Address',
       'fieldname' => 'spacer_billing_adr',
       'fieldtype' => 'spacer',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '19'),
    'billing_address_street' => array(
       'id' => '37',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Street',
       'fieldname' => 'billing_address_street',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '20'),
    'billing_address_city' => array(
       'id' => '38',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'City',
       'fieldname' => 'billing_address_city',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '21'),
    'billing_address_state' => array(
       'id' => '39',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'State',
       'fieldname' => 'billing_address_state',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '22'),
    'billing_address_postalcode' => array(
       'id' => '40',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Postal Code',
       'fieldname' => 'billing_address_postalcode',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '23'),
    'billing_address_country' => array(
       'id' => '41',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Country',
       'fieldname' => 'billing_address_country',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '24'),
    'spacer_shipping_adr' => array(
       'id' => '83',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Shipping Address',
       'fieldname' => 'spacer_shipping_adr',
       'fieldtype' => 'spacer',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '49'),
    'shipping_address_street' => array(
       'id' => '42',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Street',
       'fieldname' => 'shipping_address_street',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '50'),
    'shipping_address_city' => array(
       'id' => '43',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'City',
       'fieldname' => 'shipping_address_city',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '51'),
    'shipping_address_state' => array(
       'id' => '44',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'State',
       'fieldname' => 'shipping_address_state',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '52'),
    'shipping_address_postalcode' => array(
       'id' => '45',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Postal Code',
       'fieldname' => 'shipping_address_postalcode',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '53'),
    'shipping_address_country' => array(
       'id' => '46',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Country',
       'fieldname' => 'shipping_address_country',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '54'),
    'description' => array(
       'id' => '47',
       'bean' => 'Account',
       'bean_table' => 'accounts',
       'label' => 'Description',
       'fieldname' => 'description',
       'fieldtype' => 'textarea',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '60')),
// -------------------------
  'Contact' => array(
    'assigned_user_name' => array(
       'id' => '3',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => '',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '0',
       'orderby' => '0'),
    'assigned_user_id' => array(
       'id' => '3',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Assigned to',
       'fieldname' => 'assigned_user_id',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'account_name' => array(
       'id' => '3',
       'bean' => 'Contact',
       'bean_table' => 'accounts_contacts',
       'label' => 'Account',
       'fieldname' => 'account_name',
       'fieldtype' => 'show_only',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'account_id' => array(
       'id' => '3',
       'bean' => 'Contact',
       'bean_table' => 'accounts_contacts',
       'related_table' => 'accounts',
       'related_key' => 'account_name',
       'related_id_field' => 'contact_id',
       'related_content_field' => 'accounts.name',
       'default_content' => '',
       'default_val' => '',
       'label' => 'Related Account ID',
       'fieldname' => 'account_id',
       'fieldtype' => 'hidden',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),

  'salutation' => array(
       'id' => '48',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'related_table' => 'thin_sel_data',
       'related_key' => 'salutation',
       'related_id_field' => 'sel_idx',
       'related_content_field' => 'sel_value',
       'default_content' => '',
       'default_val' => '',
       'label' => 'Salutation',
       'fieldname' => 'salutation',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '10'),
    'first_name' => array(
       'id' => '49',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'First Name',
       'fieldname' => 'first_name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '20'),
    'last_name' => array(
       'id' => '50',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Last Name',
       'fieldname' => 'last_name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '30'),
    'department' => array(
       'id' => '52',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Department',
       'fieldname' => 'department',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '50'),
    'lead_source' => array(
       'id' => '53',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'related_table' => 'thin_sel_data',
       'related_key' => 'lead_source',
       'related_id_field' => 'sel_idx',
       'related_content_field' => 'sel_value',
       'default_content' => 'Other',
       'default_val' => '',
       'label' => 'Lead Source',
       'fieldname' => 'lead_source',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '60'),
    'birthdate' => array(
       'id' => '61',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Birthdate',
       'fieldname' => 'birthdate',
       'fieldtype' => 'date',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '130'),
    'assistant' => array(
       'id' => '62',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Assistant',
       'fieldname' => 'assistant',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '140'),
    'assistant_phone' => array(
       'id' => '63',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Assistant Phone',
       'fieldname' => 'assistant_phone',
       'fieldtype' => 'phone',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '150'),
    'description' => array(
       'id' => '47',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Description',
       'fieldname' => 'description',
       'fieldtype' => 'textarea',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '60'),
    'spacer_phone' => array(
       'id' => '64',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Phone / Fax',
       'fieldname' => 'spacer_phone',
       'fieldtype' => 'spacer',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '160'),
    'phone_home' => array(
       'id' => '58',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Home',
       'fieldname' => 'phone_home',
       'fieldtype' => 'phone',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '10'),
    'phone_work' => array(
       'id' => '54',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Office',
       'fieldname' => 'phone_work',
       'fieldtype' => 'phone',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '70'),
    'phone_fax' => array(
       'id' => '55',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Fax',
       'fieldname' => 'phone_fax',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '80'),
    'phone_mobile' => array(
       'id' => '57',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Mobile',
       'fieldname' => 'phone_mobile',
       'fieldtype' => 'phone',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '100'),
    'phone_other' => array(
       'id' => '59',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Other Phone',
       'fieldname' => 'phone_other',
       'fieldtype' => 'phone',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '110'),
    'phone_fax' => array(
       'id' => '60',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Fax',
       'fieldname' => 'phone_fax',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '120'),
    'spacer_primary_address' => array(
       'id' => '64',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Primary Address',
       'fieldname' => 'spacer_primary_address',
       'fieldtype' => 'spacer',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '160'),
    'primary_address_street' => array(
       'id' => '65',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Street',
       'fieldname' => 'primary_address_street',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '170'),
    'primary_address_city' => array(
       'id' => '66',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'City',
       'fieldname' => 'primary_address_city',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '180'),
    'primary_address_state' => array(
       'id' => '67',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'State',
       'fieldname' => 'primary_address_state',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '190'),
    'primary_address_postalcode' => array(
       'id' => '68',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Postal Code',
       'fieldname' => 'primary_address_postalcode',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '200'),
    'primary_address_country' => array(
       'id' => '69',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Country',
       'fieldname' => 'primary_address_country',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '210'),
    'spacer_other_address' => array(
       'id' => '70',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Other Address',
       'fieldname' => 'spacer_other_address',
       'fieldtype' => 'spacer',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '220'),
    'alt_address_street' => array(
       'id' => '71',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Street',
       'fieldname' => 'alt_address_street',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '230'),
    'alt_address_city' => array(
       'id' => '72',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'City',
       'fieldname' => 'alt_address_city',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '240'),
    'alt_address_state' => array(
       'id' => '73',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'State',
       'fieldname' => 'alt_address_state',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '250'),
    'alt_address_postalcode' => array(
       'id' => '74',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Postal Code',
       'fieldname' => 'alt_address_postalcode',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '260'),
    'alt_address_country' => array(
       'id' => '75',
       'bean' => 'Contact',
       'bean_table' => 'contacts',
       'label' => 'Country',
       'fieldname' => 'alt_address_country',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '270')),
// -------------------------------------------------------------------------------
  'Opportunity' => array(
    'assigned_user_name' => array(
       'id' => '3',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'label' => '',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '0',
       'orderby' => '0'),
    'assigned_user_id' => array(
       'id' => '3',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'label' => 'Assigned to',
       'fieldname' => 'assigned_user_id',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'account_name' => array(
       'id' => '3',
       'bean' => 'Opportunity',
       'bean_table' => 'accounts_opportunities',
       'label' => 'Account',
       'fieldname' => 'account_name',
       'fieldtype' => 'show_only',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'account_id' => array(
       'id' => '3',
       'bean' => 'Opportunity',
       'bean_table' => 'accounts_opportunities',
       'related_table' => 'accounts',
       'related_key' => 'account_name',
       'related_id_field' => 'opportunity_id',
       'related_content_field' => 'accounts.name',
       'default_content' => '',
       'default_val' => '',
       'label' => 'Related Account ID',
       'fieldname' => 'account_id',
       'fieldtype' => 'hidden',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),

    'name' => array(
       'id' => '3',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'label' => '',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'opportunity_type' => array(
       'id' => '4',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'related_table' => 'thin_sel_data',
       'related_key' => 'opp_type',
       'related_id_field' => 'sel_idx',
       'related_content_field' => 'sel_value',
       'default_content' => '2',
       'default_val' => '',
       'label' => '',
       'fieldname' => 'opportunity_type',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),
    'lead_source' => array(
       'id' => '5',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'related_table' => 'thin_sel_data',
       'related_key' => 'lead_source',
       'related_id_field' => 'sel_idx',
       'related_content_field' => 'sel_value',
       'default_content' => 'Other',
       'default_val' => '',
       'label' => '',
       'fieldname' => 'lead_source',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),
    'amount' => array(
       'id' => '6',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'label' => '',
       'fieldname' => 'amount',
       'fieldtype' => 'currency',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'currency_id' => array(
       'id' => '7',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'related_table' => 'currencies',
       'related_key' => '',
       'related_id_field' => 'id',
       'related_content_field' => 'iso4217',
       'default_content' => '-99',
       'default_val' => 'EUR',
       'label' => '',
       'fieldname' => 'currency_id',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),
    'date_closed' => array(
       'id' => '8',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'label' => '',
       'fieldname' => 'date_closed',
       'fieldtype' => 'date',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'next_step' => array(
       'id' => '9',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'label' => '',
       'fieldname' => 'next_step',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),
    'sales_stage' => array(
       'id' => '10',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'related_table' => 'thin_sel_data',
       'related_key' => 'sales_stage',
       'related_id_field' => 'sel_idx',
       'related_content_field' => 'sel_value',
       'default_content' => '',
       'default_val' => '',
       'label' => '',
       'fieldname' => 'sales_stage',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'probability' => array(
       'id' => '11',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'label' => '',
       'fieldname' => 'probability',
       'fieldtype' => 'percent',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),
    'description' => array(
       'id' => '12',
       'bean' => 'Opportunity',
       'bean_table' => 'opportunities',
       'label' => '',
       'fieldname' => 'description',
       'fieldtype' => 'textarea',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0')),
// -------------------------
  'Lead' => array(
    'assigned_user_name' => array(
       'id' => '3',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => '',
       'fieldname' => 'name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '0',
       'orderby' => '0'),
    'assigned_user_id' => array(
       'id' => '3',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Assigned to',
       'fieldname' => 'assigned_user_id',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '0'),
    'account_name' => array(
       'id' => '3',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Account',
       'fieldname' => 'account_name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),

    'lead_source' => array(
       'id' => '4',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Lead Source',
       'fieldname' => 'lead_source',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),
    'lead_source_description' => array(
       'id' => '4',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Lead Source Description',
       'fieldname' => 'lead_source_description',
       'fieldtype' => 'textarea',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),
    'status' => array(
       'id' => '80',
       'bean' => 'Call',
       'bean_table' => 'calls',
       'label' => 'Status',
       'fieldname' => 'status',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '40'),
    'status_description' => array(
       'id' => '4',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Status Description',
       'fieldname' => 'status_description',
       'fieldtype' => 'textarea',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '0'),
    'refered_by' => array(
       'id' => '49',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Referred By',
       'fieldname' => 'refered_by',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '20'),
    'first_name' => array(
       'id' => '49',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'First Name',
       'fieldname' => 'first_name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '20'),
    'last_name' => array(
       'id' => '50',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Last Name',
       'fieldname' => 'last_name',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '1',
       'visible' => '1',
       'orderby' => '30'),
    'title' => array(
       'id' => '52',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Title',
       'fieldname' => 'title',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '50'),
    'department' => array(
       'id' => '52',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Department',
       'fieldname' => 'department',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '50'),
    'lead_source' => array(
       'id' => '53',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'related_table' => 'thin_sel_data',
       'related_key' => 'lead_source',
       'related_id_field' => 'sel_idx',
       'related_content_field' => 'sel_value',
       'default_content' => 'Other',
       'default_val' => '',
       'label' => 'Lead Source',
       'fieldname' => 'lead_source',
       'fieldtype' => 'enum',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '60'),
    'description' => array(
       'id' => '47',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Description',
       'fieldname' => 'description',
       'fieldtype' => 'textarea',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '60'),
    'spacer_phone' => array(
       'id' => '64',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Phone / Fax',
       'fieldname' => 'spacer_phone',
       'fieldtype' => 'spacer',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '160'),
    'phone_work' => array(
       'id' => '54',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Office',
       'fieldname' => 'phone_work',
       'fieldtype' => 'phone',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '70'),
    'phone_mobile' => array(
       'id' => '57',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Mobile',
       'fieldname' => 'phone_mobile',
       'fieldtype' => 'phone',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '100'),
    'phone_home' => array(
       'id' => '58',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Home',
       'fieldname' => 'phone_home',
       'fieldtype' => 'phone',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '10'),
    'phone_other' => array(
       'id' => '59',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Other Phone',
       'fieldname' => 'phone_other',
       'fieldtype' => 'phone',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '110'),
    'phone_fax' => array(
       'id' => '55',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Fax',
       'fieldname' => 'phone_fax',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '80'),
    'email1' => array(
       'id' => '55',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Email',
       'fieldname' => 'email1',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '80'),
    'spacer_primary_address' => array(
       'id' => '64',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Primary Address',
       'fieldname' => 'spacer_primary_address',
       'fieldtype' => 'spacer',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '160'),
    'primary_address_street' => array(
       'id' => '65',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Street',
       'fieldname' => 'primary_address_street',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '170'),
    'primary_address_city' => array(
       'id' => '66',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'City',
       'fieldname' => 'primary_address_city',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '180'),
    'primary_address_state' => array(
       'id' => '67',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'State',
       'fieldname' => 'primary_address_state',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '190'),
    'primary_address_postalcode' => array(
       'id' => '68',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Postal Code',
       'fieldname' => 'primary_address_postalcode',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '200'),
    'primary_address_country' => array(
       'id' => '69',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Country',
       'fieldname' => 'primary_address_country',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '210'),
    'spacer_other_address' => array(
       'id' => '70',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Other Address',
       'fieldname' => 'spacer_other_address',
       'fieldtype' => 'spacer',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '220'),
    'alt_address_street' => array(
       'id' => '71',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Street',
       'fieldname' => 'alt_address_street',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '230'),
    'alt_address_city' => array(
       'id' => '72',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'City',
       'fieldname' => 'alt_address_city',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '240'),
    'alt_address_state' => array(
       'id' => '73',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'State',
       'fieldname' => 'alt_address_state',
       'fieldtype' => 'varchar',
       'statement' => '',
       'required' => '0',
       'visible' => '1',
       'orderby' => '250'),
    'alt_address_postalcode' => array(
       'id' => '74',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Postal Code',
       'fieldname' => 'alt_address_postalcode',
       'fieldtype' => 'varchar',
       'statement' => '',
       'required' => '0',
       'visible' => '1',
       'orderby' => '260'),
    'alt_address_country' => array(
       'id' => '75',
       'bean' => 'Lead',
       'bean_table' => 'leads',
       'label' => 'Country',
       'fieldname' => 'alt_address_country',
       'fieldtype' => 'varchar',
       'statement' => '',

       'required' => '0',
       'visible' => '1',
       'orderby' => '270')),

  );
?>